{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["HELP","HOME","TEMPLATE - QUOTATION","TEMPLATE - INVOICE","SETTINGS","INVOICE - REPORT","CUSTOMER - REPORT","MONTHLY - REPORT","SALES MAN - REPORT","INVENTORY - REPORT","P & L - REPORT","EXPENSE - REPORT","PENDING PAYMENT - REPORT","INVOICE DB","INVOICE - INVENTORY DB","INVENTORY DB","EXPENSE DB","CUSTOMER DB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HELP","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,2,9],[17,2,20,13],[26,2,26,13],[27,2,27,13],[28,2,28,9],[28,10,28,11],[21,2,21,4],[14,2,14,13],[23,2,23,7],[23,8,23,9]]}
[]
[null,null,"RETAIL MANAGER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"About:"]
[null,null,"RETAIL MANAGER  is a simple excel based tool which helps you to generate invoices & quotations, track your expenses & payments, manage your stocks and generates reports for you based on your criterias. You can start using the tool by changing the settings for your business in the \"SETTINGS\" sheet. This being an excel based tool is easy to use and need no separate installations. You just needed to have Microsoft Excel installed in your computer."]
[]
[]
[]
[null,null,"How it works"]
[]
[null,null,"To see how the tool works, please see the youtube help vedio by clicking on the link",null,null,null,null,null,"here"]
[]
[null,null,"Pre-requisite"]
[null,null,"1. The file is compatible with any version of Microsoft Windows Operating System. Other Operating systems are not supported.\n"]
[null,null,"2. You should have Microsoft Excel 2007 or higher version installed in your computer.\n3. You have to enable Macros in your excel. To know more on how to enable macro always, please check the link .\n"]
[null,null,"3. You have to enable Macros in your excel. To know more on how to enable macro always, please check the link .",null,null,null,null,null,null,null,"here"]

{"sheet":"HOME","index":1,"n_rows":11,"n_cols":18,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,0,1,15],[4,11,4,13],[23,11,23,14],[23,6,23,9],[23,1,23,4],[6,11,6,13],[10,1,10,4],[10,6,10,14]]}
[]
["RETAIL MANAGER"]
[]
[]
[null,"TRIAL VERSION",null,null,null,null,null,null,null,null,null,"Next Invoice Number : ",null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Your LOGO will be placed here",null,null,null,null,null,null,null,null,null,"Next Quotation Number : ",null,null,1,null,null,"2020-04-19"]
[]
[]
[]
[null,"FUNCTIONALITIES",null,null,null,null,"REPORTS"]

{"sheet":"TEMPLATE - QUOTATION","index":2,"n_rows":75,"n_cols":7,"rows_kept":75,"cut":false,"hidden":true,"merged":[[63,1,63,3],[4,5,4,6],[5,5,5,6],[6,5,6,6],[65,1,65,3],[52,1,52,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[72,4,72,5],[68,4,68,5],[69,4,69,5],[70,4,70,5],[64,1,64,3],[67,4,67,5],[71,4,71,5],[66,3,66,4],[51,1,51,3],[40,1,40,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[28,1,28,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[12,4,12,5],[3,0,3,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[0,2,0,6],[0,0,0,1],[74,4,77,6],[73,4,73,5],[6,0,6,3],[2,0,2,3],[4,0,4,3],[5,0,5,3],[16,1,16,3],[9,1,9,3],[9,4,9,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,3]]}
["TRIAL VERSION",null,{"$f":"SETTINGS!K19","v":"QUOTATION"}]
[]
[{"$f":"SETTINGS!D6","v":"Company Name"},null,null,null,null,"Date:"]
[{"$f":"SETTINGS!D8","v":"Add 1"},null,null,null,null,"Quotation #:"]
[{"$f":"SETTINGS!D10","v":"Add 2"}]
[{"$f":"SETTINGS!D12","v":"Add 3"}]
[{"$f":"SETTINGS!D14","v":"Add 4"}]
[]
[]
["To:"]
[]
[]
[]
[]
[]
["Qty","Description",null,null,"Unit Price","Dis","Line Total"]
[null,null,null,null,null,{"$f":"IF(E17<>0,SETTINGS!$E$27,\"\")","v":""},{"$f":"IFERROR(IF(A17<>\"\",(A17*E17)-(A17*E17*F17),\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E18<>0,SETTINGS!$E$27,\"\")","v":""},{"$f":"IFERROR(IF(A18<>\"\",(A18*E18)-(A18*E18*F18),\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E19<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E20<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E21<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E22<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E23<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E24<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E25<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E26<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E27<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E28<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E29<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E30<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E31<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E32<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E33<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E34<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E35<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E36<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E37<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E38<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E39<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E40<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E41<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E42<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E43<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E44<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E45<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E46<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E47<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E48<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E49<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E50<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E51<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E52<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E53<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E54<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E55<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E56<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E57<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E58<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E59<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E60<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E61<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E62<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E63<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E64<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E65<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E66<>0,SETTINGS!$E$27,\"\")","v":""},""]
[]
[null,null,null,null,"Subtotal",null,{"$f":"IFERROR(SUM(G17:G66),\"\")","v":0}]
[null,null,null,null,{"$f":"SETTINGS!F21","v":"SGST 9%"},null,{"$f":"IFERROR(+G68*SETTINGS!I21,\"\")","v":0}]
[null,null,null,null,{"$f":"SETTINGS!F23","v":"CGST 9%"},null,{"$f":"IFERROR(+G68*SETTINGS!I23,\"\")","v":0}]
[null,null,null,null,{"$f":"SETTINGS!F25","v":0},null,{"$f":"IFERROR(+G68*SETTINGS!I25,\"\")","v":0}]
[null,null,null,null,"Packing Charges",null,{"$f":"IF(G68<>0,SETTINGS!I31,0)","v":0}]
[null,null,null,null,"Delivery charges",null,{"$f":"IF(G68<>0,SETTINGS!I29,0)","v":0}]
[null,null,null,null,"Total",null,{"$f":"SUM(G68:G73)","v":0}]
[null,null,null,null,{"$f":"SpellNumber(\"Rupees \",G74)","v":"Rupees  Zero Only"}]

{"sheet":"TEMPLATE - INVOICE","index":3,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":true,"merged":[[4,6,5,6],[10,4,10,5],[9,4,9,5],[2,0,2,3],[3,0,3,3],[4,0,4,3],[6,0,6,3],[9,1,9,3],[10,1,10,3],[5,0,5,3],[57,1,57,2],[11,4,11,5],[12,4,12,5],[11,1,11,3],[12,1,12,3],[13,1,13,3],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[38,1,38,2],[39,1,39,2],[14,1,14,3],[16,1,16,2],[17,1,17,2],[28,1,28,2],[29,1,29,2],[74,4,76,6],[76,1,76,3],[72,4,72,5],[42,1,42,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[40,1,40,2],[41,1,41,2],[52,1,52,2],[0,2,0,6],[0,0,0,1],[77,1,77,3],[74,1,74,3],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[75,1,75,3],[66,3,66,4],[67,4,67,5],[71,4,71,5]]}
["TRIAL VERSION",null,{"$f":"SETTINGS!I19","v":"SALES INVOICE"}]
[]
[{"$f":"SETTINGS!D6","v":"Company Name"},null,null,null,null,"Date:"]
[{"$f":"SETTINGS!D8","v":"Add 1"},null,null,null,null,"Invoice #:"]
[{"$f":"SETTINGS!D10","v":"Add 2"},null,null,null,null,{"$f":"IF(G5<>\"\",\"Sales Man :\",\"\")","v":""}]
[{"$f":"SETTINGS!D12","v":"Add 3"}]
[{"$f":"SETTINGS!D14","v":"Add 4"}]
[]
[]
["To:"]
[]
[]
[]
[]
[]
["Qty","Description",null,"MRP","Unit Price","Dis","Line Total"]
[null,null,null,null,null,{"$f":"IF(E17<>0,SETTINGS!$E$27,\"\")","v":""},{"$f":"IFERROR(IF(A17<>\"\",(A17*E17)-(A17*E17*F17),\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E18<>0,SETTINGS!$E$27,\"\")","v":""},{"$f":"IFERROR(IF(A18<>\"\",(A18*E18)-(A18*E18*F18),\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E19<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E20<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E21<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E22<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E23<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E24<>0,SETTINGS!$E$27,\"\")","v":""},{"$f":"IFERROR(IF(A24<>\"\",(A24*E24)-(A24*E24*F24),\"\"),0)","v":""}]
[null,null,null,null,null,{"$f":"IF(E25<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E26<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E27<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E28<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E29<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E30<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E31<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E32<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E33<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E34<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E35<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E36<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E37<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E38<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E39<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E40<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E41<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E42<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E43<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E44<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E45<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E46<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E47<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E48<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E49<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E50<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E51<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E52<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E53<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E54<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E55<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E56<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E57<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E58<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E59<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E60<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E61<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E62<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E63<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E64<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E65<>0,SETTINGS!$E$27,\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IF(E66<>0,SETTINGS!$E$27,\"\")","v":""},""]
[]
[{"$f":"SUM(A17:A66)","v":0},null,null,null,"Subtotal",null,{"$f":"IFERROR(SUM(G17:G66),\"\")","v":0}]
[null,null,null,null,null,{"$f":"SETTINGS!F21","v":"SGST 9%"},{"$f":"IFERROR(+G68*SETTINGS!I21,\"\")","v":0}]
[null,null,null,null,null,{"$f":"SETTINGS!F23","v":"CGST 9%"},{"$f":"IFERROR(+G68*SETTINGS!I23,\"\")","v":0}]
[null,null,null,null,null,{"$f":"SETTINGS!F25","v":0},{"$f":"IFERROR(+G68*SETTINGS!I25,\"\")","v":0}]
[null,null,null,null,"Packing Charges",null,{"$f":"IF(G68<>0,SETTINGS!I31,0)","v":0}]
[null,null,null,null,"Delivery charges",null,{"$f":"IF(G68<>0,SETTINGS!I29,0)","v":0}]
[null,{"$f":"IF(SETTINGS!J6<>\"\",\"Bank Details\",\"\")","v":""},null,null,null,"Total",{"$f":"ROUND(SUM(G68:G73),0)","v":0}]
[null,{"$f":"IF(SETTINGS!J6<>\"\",SETTINGS!J6,\"\")","v":""},null,null,{"$f":"SpellNumber(\"Rupees\",G74)","v":"Rupees Zero Only"}]
[null,{"$f":"IF(SETTINGS!J8<>\"\",SETTINGS!J8,\"\")","v":""}]
[null,{"$f":"IF(SETTINGS!J10<>\"\",SETTINGS!J10,\"\")","v":""}]

{"sheet":"SETTINGS","index":4,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,1,1,11],[5,3,5,7],[7,3,7,7],[9,3,9,7],[11,3,11,7],[5,8,13,8],[5,9,5,10],[7,9,7,10],[9,9,9,10],[13,3,13,7],[38,2,39,2],[39,4,39,9],[36,2,37,2],[37,4,37,9],[34,9,34,10]]}
[]
[null,"SETTINGS"]
[]
[null,"General Settings"]
[]
[null,null,"Company Name :","Company Name",null,null,null,null,"Bank Details to be displayed in Invoice if required :"]
[]
[null,null,"Address Line 1 :","Add 1"]
[]
[null,null,"Address Line 2 :","Add 2"]
[]
[null,null,"Address Line 3 :","Add 3"]
[]
[null,null,"Address Line 4 :","Add 4"]
[]
[]
[null,"Invoice & Quotation Settings"]
[]
[null,null,"Select Currency",null,"Rs",null,null,"Invoice Heading","SALES INVOICE","Quotation Heading","QUOTATION"]
[]
[null,null,"Tax 1 :",null,"Tax Name","SGST 9%",null,"Percentage",0.09,"Show in Invoice","Yes"]
[]
[null,null,"Tax 2 :",null,"Tax Name","CGST 9%",null,"Percentage",0.09,"Show in Invoice","Yes"]
[]
[null,null,"Tax 3 :",null,"Tax Name",null,null,"Percentage",null,"Show in Invoice","No"]
[]
[null,null,"Default Discount % :",null,0]
[]
[null,null,"Delivery charge :",null,"Show in Invoice","No",null,"Default Value",0]
[]
[null,null,"Packing Charge :",null,"Show in Invoice","No",null,"Default Value",0]
[]
[null,null,"Default Payment Status :",null,"Paid"]
[]
[null,null,"Notify if Qty entered in invoice is greater than the quantity available in stock :",null,null,null,null,null,"Yes","(For Service sector businesses select 'No')"]
[]
[null,null,"Default location where Invoices are to be saved :"]
[]
[null,null,"Default location where Quotation are to be saved :"]

{"sheet":"INVOICE - REPORT","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[0,0,0,7],[1,0,1,2],[4,0,4,2],[5,0,5,2],[2,5,2,6],[3,5,3,6],[1,3,1,6],[2,3,2,4],[3,3,3,4],[2,0,2,2],[3,0,3,2]]}
["INVOICE REPORT"]
[null,null,null,"Search Criteria:"]
[null,null,null,"Customer Name :",null,"All"]
[null,null,null,"Date Range :",null,"Aug-2018 To Aug-2018"]
[]
[]
[]
["Date","Invoice #","Customer Name","Subtotal","Tax Total","P & D Charges","Total"]
["2018-08-28",1,"Bag Mall",2865,515.69999999999993,0,3380.7,20180828,"Kunal Shah"]
[]
["TOTAL",null,null,2865,515.69999999999993,0,3380.7]

{"sheet":"CUSTOMER - REPORT","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[0,0,0,6],[3,5,3,6],[3,0,3,3],[4,0,4,3],[5,0,5,3],[2,5,2,6],[1,0,1,3],[2,0,2,3]]}
["CUSTOMER SALES REPORT"]
[null,null,null,null,"Search Criteria:"]
[null,null,null,null,"Customer Name :",{"$f":"'INVOICE - REPORT'!F3:G3","v":"All"}]
[null,null,null,null,"Date Range :","Aug-2018 To Aug-2018"]
[]
[]
[]
["Customer Name",null,null,"Subtotal","Tax Total","P & D Charges","Total"]
["Bag Mall",null,null,2865,515.69999999999993,0,3380.7]
[]
["TOTAL",null,null,2865,515.69999999999993,0,3380.7]

{"sheet":"MONTHLY - REPORT","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[4,0,4,3],[5,0,5,3],[1,4,1,6],[0,0,0,6],[1,0,1,3],[2,0,2,3],[2,5,2,6],[3,0,3,3],[3,5,3,6]]}
["MONTHLY SALES REPORT"]
[null,null,null,null,"Search Criteria:"]
[null,null,null,null,"Customer Name :",{"$f":"'INVOICE - REPORT'!F3:G3","v":"All"}]
[null,null,null,null,"Date Range :","Aug-2018 To Aug-2018"]
[]
[]
[]
["Month Name",null,null,"Subtotal","Tax Total","P & D Charges","Total"]
["2018-08-01",null,null,2865,515.69999999999993,0,3380.7]
[]
["TOTAL",null,null,2865,515.69999999999993,0,3380.7]

{"sheet":"SALES MAN - REPORT","index":8,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,10,2],[4,0,4,3],[5,0,5,3],[0,0,0,6],[1,0,1,3],[1,4,1,6],[2,0,2,3],[2,5,2,6],[3,0,3,3],[3,5,3,6]]}
["SALES MEN WISE REPORT"]
[null,null,null,null,"Search Criteria:"]
[null,null,null,null,"Customer Name :",{"$f":"IF('MONTHLY - REPORT'!F3<>\"\",'MONTHLY - REPORT'!F3,\"\")","v":"All"}]
[null,null,null,null,"Date Range :",{"$f":"IF('MONTHLY - REPORT'!F4<>\"\",'MONTHLY - REPORT'!F4,\"\")","v":"Aug-2018 To Aug-2018"}]
[]
[]
[]
["Sales Man Name",null,null,"Subtotal","Tax Total","P & D Charges","Total"]
["Kunal Shah",null,null,2865,515.69999999999993,0,3380.7]
[]
["TOTAL",null,null,2865,515.69999999999993,0,3380.7]

{"sheet":"INVENTORY - REPORT","index":9,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,2],[9,0,9,2],[1,2,1,4],[0,0,0,4],[7,0,7,2],[2,3,2,4],[3,3,3,4],[8,0,8,2]]}
["INVENTORY SALES REPORT"]
[null,null,"Search Criteria"]
[null,null,"Customer Name :","All"]
[null,null,"Date Range :","Aug-2018 To Aug-2018"]
[]
[]
[]
["Product",null,null,"Quantity","Sale  Amount"]
["Lappie Rose (No)",null,null,3,1677]
["Collegian (No)",null,null,3,1188]
[]
["TOTAL",null,null,6,2865]

{"sheet":"P & L - REPORT","index":10,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,2,1,4],[2,3,2,4],[3,3,3,4]]}
["P & L REPORT"]
[null,null,"Search Criteria"]
[null,null,"Customer Name :",{"$f":"'INVENTORY - REPORT'!D3:E3","v":"All"}]
[null,null,"Date Range :",{"$f":"'INVENTORY - REPORT'!D4:E4","v":"Aug-2018 To Aug-2018"}]
[]
[]
[]
["Total Selling Price after Discount :",null,2865,null,"Collegian"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(E8,'INVENTORY DB'!B:H,7,FALSE),0)","v":242}]
["Total Cost Price :",null,1947]
[]
["Profit :",null,{"$f":"C8-C10","v":918}]

{"sheet":"EXPENSE - REPORT","index":11,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,2],[4,0,4,3],[5,0,5,3],[0,0,0,6],[1,0,1,3],[1,4,1,6],[2,0,2,3],[2,5,2,6],[3,0,3,3],[3,5,3,6]]}
["EXPENSE REPORT"]
[null,null,null,null,"Search Criteria:"]
[null,null,null,null,"Customer Name :","All"]
[null,null,null,null,"Date Range :","Jan-2013 To Jul-2014"]
[]
[]
[]
["Expense Type",null,null,"Date","Date","Vendor  Name","Amount"]
["Marketting Expense",null,null,null,"2014-06-28","Testr",200,20140628]
["Purchase",null,null,null,"2014-06-30","Ventor 1",100,20140630]
[]
["TOTAL",null,null,null,null,null,300]

{"sheet":"PENDING PAYMENT - REPORT","index":12,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,2],[11,0,11,2],[0,0,0,7],[1,0,1,2],[1,3,1,6]]}
["PENDING PAYMENT REPORT"]
["SUMMARY",null,null,"Select Period"]
["Total Invoiced :",{"$f":"SUM('INVOICE DB'!M:M)","v":0},null,null,null,"2018-01-01","2019-01-01"]
["Total Paid:",{"$f":"SUM('INVOICE DB'!P:P)","v":0},null,null,null,"Total Invoiced :",{"$f":"SUMIFS('INVOICE DB'!$M:$M,'INVOICE DB'!$A:$A,\">=\" & F$3,'INVOICE DB'!$A:$A,\"<=\" & G$3)","v":0}]
["Total Outstanding :",{"$f":"B3-B4","v":0},null,null,null,"Total Paid:",{"$f":"SUMIFS('INVOICE DB'!$P:$P,'INVOICE DB'!$A:$A,\">=\" & F$3,'INVOICE DB'!$A:$A,\"<=\" & G$3)","v":0}]
["DEALER SUMMARY"]
["Dealer Name :","Bag Mall"]
["Date","Invoice #","Customer Name",null,null,"Invoice Amount","Paid Amount"]
["2018-08-28",1,"Bag Mall",null,null,3380.7,3380.7,2018828]
["2018-09-01","2","Bag Mall",null,null,3380.7,6761.4,2018901]
[]
["TOTAL",null,null,null,null,6761.4,10142.099999999999]
["OUTSTANDING AMOUNT :",null,null,null,null,null,-3380.6999999999989]

{"sheet":"INVOICE DB","index":13,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"INVOICE DATABASE"]
["Date:","Invoice No:  BB/","Store #","Date Delivered","PST #","Customer","Subtotal",{"$f":"SETTINGS!F21","v":"SGST 9%"},{"$f":"SETTINGS!F23","v":"CGST 9%"},{"$f":"SETTINGS!F25","v":0},"Packing Charges","Delivery Charges","Total","Payment Status","Sales Man","Payments"]

{"sheet":"INVOICE - INVENTORY DB","index":14,"n_rows":2,"n_cols":18,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,0,0,17]]}
["INVOICE - INVENTORY DATABASE"]
["Date:","Invoice #:","Store #","Date Delivered","PST #","Customer","Qty","Description","Unit Price","Dis","Line Total","Sub Total",{"$f":"SETTINGS!F21","v":"SGST 9%"},{"$f":"SETTINGS!F23","v":"CGST 9%"},{"$f":"SETTINGS!F25","v":0},"Packing Charges","Delivery charges","Total"]

{"sheet":"INVENTORY DB","index":15,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["INVENTORY DATABASE"]
[]
[null,"INVENTORY DATABASE"]
["Category","Product Name","Stock Qty","Unit",null,"Selling Price","MRP","Cost Price"]
["Backpack","Lappie Rose",12,"No",null,559,1199,407]
["Backpack","Collegian",141,"No",null,396,850,242]
["Backpack","Jasmine ",27,"No",null,489,1050,326]
["Backpack","Campus",144,"No",null,489,1050,320]
["Backpack","Carrie Cute",211,"No",null,326,699,218]
["Tote","Iconic ",132,"No",null,396,850,294]
["Backpack","Heart and Polka",14,"No",null,{"$f":"F10+10","v":406},1150,390]
["Backpack","Gizelle FLR",4,"No",null,536,1150,376]
["Backpack","Gizelle ABST",14,"No",null,443,950,304]
["Backpack","Mini Blossom",8,"No",null,396,850,251]
["BnT","China Sample",20,"No",null,600,1000,500]
["Backpack","Freeda ",4,"No",null,758,1790,577]
["Backpack","Serena ",29,"No",null,758,1790,571]
["Backpack","Julie",27,"No",null,742,1750,554]
["Backpack","Rose ",37,"No",null,631,1490,456]

{"sheet":"EXPENSE DB","index":16,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["EXPENSE DATABASE"]
["Date:","Expense Type","Vendor Name ( if Applicable)","Description","Amount"]

{"sheet":"CUSTOMER DB","index":17,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,0,0,8]]}
["CUSTOMER DATABASE",null,null,null,null,null,null,null,null,null,"SALES MAN DB"]
["Code","Customer Name","Add Line 1","Add Line 2","Contact Person","HSN No","GSTIN No","PST #",null,null,"Sales Man Name"]
["Bag Mall","Bag Mall","Shop 2, Shanti Bldg,Chandavarkar Lane",", Borivali W, Mumbai 400092, Maharashtra","Contact Person: Pandey         Contact No: 9867053867",null,"GSTIN:   27AADAPM4915K1Z8                          HSN Code: 4202",null,null,null,"Kunal Shah"]
["Code 2","Dealer 2","Add Line 2","Add Line 3","Contact Person: Name 2",null,"GSTIN:",null,null,null,"Sales Name 2"]
["Code 3","Dealer 3","Add Line 2","Add Line 3","Contact Person: Name 3",null,"GSTIN:",null,null,null,"Sales Name 3"]
["Code 4","Dealer 4","Add Line 2","Add Line 3","Contact Person: Name 4",null,"GSTIN:",null,null,null,"Sales Name 4"]
["Code 5","Dealer 5","Add Line 2","Add Line 3","Contact Person: Name 5",null,"GSTIN:",null,null,null,"Sales Name 5"]
["Code 6","Dealer 6","Add Line 2","Add Line 3","Contact Person: Name 6",null,"GSTIN:",null,null,null,"Sales Name 6"]
["Code 7","Dealer 7","Add Line 2","Add Line 3","Contact Person: Name 7",null,"GSTIN:",null,null,null,"Sales Name 7"]
["Code 8","Dealer 8","Add Line 2","Add Line 3","Contact Person: Name 8",null,"GSTIN:",null,null,null,"Sales Name 8"]
["Code 9","Dealer 9","Add Line 2","Add Line 3","Contact Person: Name 9",null,"GSTIN:",null,null,null,"Sales Name 9"]
["Code 10","Dealer 10","Add Line 2","Add Line 3","Contact Person: Name 10",null,"GSTIN:",null,null,null,"Sales Name 10"]
["Code 11","Dealer 11","Add Line 2","Add Line 3","Contact Person: Name 11",null,"GSTIN:"]
["Code 12","Dealer 12","Add Line 2","Add Line 3","Contact Person: Name 12",null,"GSTIN:"]
["Code 13","Dealer 13","Add Line 2","Add Line 3","Contact Person: Name 13",null,"GSTIN:"]
["Code 14","Dealer 14","Add Line 2","Add Line 3","Contact Person: Name 14",null,"GSTIN:"]